package com.government.item.service;

import java.util.List;

import com.government.item.bo.ItemDataListBO;
import com.government.item.domain.ExcelDetail;
import com.government.item.domain.ExcelList;
import com.government.item.vo.ItemData;
import com.government.item.vo.ItemStatisticsData;

/**
 * excel记录Service接口
 *
 * @author system
 * @date 2023-09-19
 */
public interface IExcelListService {
    /**
     * 查询excel记录
     *
     * @param id excel记录主键
     * @return excel记录
     */
    public ExcelList selectExcelListById(Long id);

    /**
     * 查询excel记录列表
     *
     * @param excelList excel记录
     * @return excel记录集合
     */
    public List<ExcelList> selectExcelListList(ExcelList excelList);

    List<ExcelDetail> getExcelDetail(Long id);
    /**
     * 新增excel记录
     *
     * @param excelList excel记录
     * @return 结果
     */
    public int insertExcelList(ExcelList excelList);

    /**
     * 修改excel记录
     *
     * @param excelList excel记录
     * @return 结果
     */
    public int updateExcelList(ExcelList excelList);

    /**
     * 批量删除excel记录
     *
     * @param ids 需要删除的excel记录主键集合
     * @return 结果
     */
    public int deleteExcelListByIds(Long[] ids);

    /**
     * 删除excel记录信息
     *
     * @param id excel记录主键
     * @return 结果
     */
    public int deleteExcelListById(Long id);

    /**
     * 根据政策id获取立项数据
     *
     * @param policyId
     * @return
     */
    List<ItemData> getItemDataList(Long policyId);

    /**
     * 导入立项数据
     * @param excelDetailList
     * @param policyId
     * @param fileName
     */
    void importData(String url,List<ExcelDetail> excelDetailList, String policyId, String fileName);

    List<ItemStatisticsData> getItemStatisticsByAmount(ItemDataListBO bo);

    List<ItemStatisticsData> getItemStatisticsByArea(ItemDataListBO bo);

    List<ItemStatisticsData> getItemStatisticsByNature(ItemDataListBO bo);

    List<ItemStatisticsData> getItemStatisticsByIndustry(ItemDataListBO bo);

    List<ItemStatisticsData> getCompanyItemStatisticsByAmount(ItemDataListBO bo);

    List<ItemStatisticsData> getCompanyItemStatisticsByLevel(ItemDataListBO bo);

    List<ItemStatisticsData> getCompanyItemStatisticsByOrg(ItemDataListBO bo);

    List<ItemStatisticsData> getCompanyItemStatisticsByYear(ItemDataListBO bo);

    String getCompanyItemStatistics(ItemDataListBO bo);

    void failDataHandler();
}
